[CHAPTER 04. WAL Buffer와 Wait Event]

4. CASE STUDY
4-1. CASE1: `wal_buffers` Parameter 조정


DROP TABLE IF EXISTS wal_test;
CREATE TABLE wal_test (
    a INTEGER PRIMARY KEY,
    b INTEGER[]
);

INSERT INTO wal_test
SELECT   pg_catalog.generate_series(1, 10000),
         (SELECT array_agg(a)
          FROM pg_catalog.generate_series(1, 100) t(a));
          
pg_lw_lock_tracer -p 509470 -v --statistics >> wal_test_1.log


4-2. CASE2: `full_page_writes` Parameter 조정

DROP TABLE IF EXISTS wal_test;
CREATE TABLE wal_test (
    a INTEGER PRIMARY KEY,
    b INTEGER[]
    
);

INSERT INTO wal_test
SELECT   pg_catalog.generate_series(1, 10000),
         (SELECT array_agg(a)
          FROM pg_catalog.generate_series(1, 100) t(a));
          
pg_lw_lock_tracer -p 509470 -v --statistics >> wal_test_2.log          
